home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The CICA Windows Explosion!
/
The CICA Windows Explosion! - Disc 2.iso
/
pdoxwin
/
pi0794.zip
/
SQLSPY.EXE
/
SQLTVIEW.TXT
< prev
next >
Wrap
Text File
|
1994-05-26
|
1KB
|
38 lines
Help Text for SQLTVIEW.FSL - SQL Table Viewer Object PAL Application
====================================================================
This Object PAL Application is a simple utility to view standard
Paradox Tables and/or SQL SERVER(SYBASE) Tables if you have installed
SQL LINK.
For SQL Tables, this form can perform the following:
1. Display Structure ('info structure' type function on the Table ).
2. Display Indexes.
3. Display Contents of the Table Selected.
4. User List of the SQL Server.
5. Displays information about object dependencies ie
The views and procedures that depend on the table or view specified.
6. Adhoc Query Facility (Only for an SQL Sybase Alias)
For Local tables (PARADOX,DBASE), SQLTVIEW performs the first five functions.
Note that with SYBASE SQL , Table structure info is not readily
available. Requires stored procedure sp_displaystructure to be
catalogued to make this work.
Table Viewer App consists of four forms and a Stored Procedure:
SQLTVIEW.FSL SQL/Paradox Table Viewer Main Form
ALIASLST.FSL Form to select Alias
GTPASSWD.FSL Gets Password from user for an SQL ALIAS
SQLQUERY.FSL Adhoc Query Form for SQL Aliases
DISPSTRU.SQL Stored procedure used for displaying
SYBASE TABLE STRUCTURES
Sundar Rajan